Tabela PhLotSerialNumberVerifi

Definicja tabeli PhLotSerialNumberVerifi

Name

PhLotSerialNumberVerifi

Code

PhLotSerialNumberVerifi

Comment

PL: tabela przechowuje informacje o zaczytanych kodach QR z opakowan


Lista kolumn tabeli PhLotSerialNumberVerifi

Name

Code

LotSerialNumberVerifiID

LotSerialNumberVerifiID

LotID

LotID

QrCode

QrCode

Gtin

Gtin

SerialNumber

SerialNumber

ValidityDT

ValidityDT

VerifiDT

VerifiDT

WithdrawalDT

WithdrawalDT

ItemNo

ItemNo

Active

Active

LotSNVerifiStatusID

LotSNVerifiStatusID

LotWithdrawalTypeID

LotWithdrawalTypeID

StateText

StateText

StateCode

StateCode

LotNMVSStatusID

LotNMVSStatusID


Kolumna LotSerialNumberVerifiID tabeli PhLotSerialNumberVerifi

Definicja kolumny LotSerialNumberVerifiID tabeli PhLotSerialNumberVerifi

Name

LotSerialNumberVerifiID

Code

LotSerialNumberVerifiID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LotID tabeli PhLotSerialNumberVerifi

Definicja kolumny LotID tabeli PhLotSerialNumberVerifi

Name

LotID

Code

LotID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna QrCode tabeli PhLotSerialNumberVerifi

Definicja kolumny QrCode tabeli PhLotSerialNumberVerifi

Name

QrCode

Code

QrCode

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

zeskanowany kod seryjny


Kolumna Gtin tabeli PhLotSerialNumberVerifi

Definicja kolumny Gtin tabeli PhLotSerialNumberVerifi

Name

Gtin

Code

Gtin

Data Type

VARCHAR2(16)

Mandatory

No

Comment

kod gtin


Kolumna SerialNumber tabeli PhLotSerialNumberVerifi

Definicja kolumny SerialNumber tabeli PhLotSerialNumberVerifi

Name

SerialNumber

Code

SerialNumber

Data Type

VARCHAR2(32)

Mandatory

No

Comment

kod seryjny


Kolumna ValidityDT tabeli PhLotSerialNumberVerifi

Definicja kolumny ValidityDT tabeli PhLotSerialNumberVerifi

Name

ValidityDT

Code

ValidityDT

Data Type

DATE

Mandatory

No

Comment

data waznosci


Kolumna VerifiDT tabeli PhLotSerialNumberVerifi

Definicja kolumny VerifiDT tabeli PhLotSerialNumberVerifi

Name

VerifiDT

Code

VerifiDT

Data Type

DATE

Mandatory

No

Comment

data weryfikacji w systemie nmvs


Kolumna WithdrawalDT tabeli PhLotSerialNumberVerifi

Definicja kolumny WithdrawalDT tabeli PhLotSerialNumberVerifi

Name

WithdrawalDT

Code

WithdrawalDT

Data Type

DATE

Mandatory

No

Comment

data wycofania w systemie nmvs


Kolumna ItemNo tabeli PhLotSerialNumberVerifi

Definicja kolumny ItemNo tabeli PhLotSerialNumberVerifi

Name

ItemNo

Code

ItemNo

Data Type

NUMBER(10)

Mandatory

No

Comment

numer pozycji


Kolumna Active tabeli PhLotSerialNumberVerifi

Definicja kolumny Active tabeli PhLotSerialNumberVerifi

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

aktywnosc rekordu


Kolumna LotSNVerifiStatusID tabeli PhLotSerialNumberVerifi

Definicja kolumny LotSNVerifiStatusID tabeli PhLotSerialNumberVerifi

Name

LotSNVerifiStatusID

Code

LotSNVerifiStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LotWithdrawalTypeID tabeli PhLotSerialNumberVerifi

Definicja kolumny LotWithdrawalTypeID tabeli PhLotSerialNumberVerifi

Name

LotWithdrawalTypeID

Code

LotWithdrawalTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StateText tabeli PhLotSerialNumberVerifi

Definicja kolumny StateText tabeli PhLotSerialNumberVerifi

Name

StateText

Code

StateText

Data Type

VARCHAR2(255)

Mandatory

No

Comment

stan leku w bazie nmvs opis


Kolumna StateCode tabeli PhLotSerialNumberVerifi

Definicja kolumny StateCode tabeli PhLotSerialNumberVerifi

Name

StateCode

Code

StateCode

Data Type

VARCHAR2(20)

Mandatory

No

Comment

stan leku w bazie nmvs kod


Kolumna LotNMVSStatusID tabeli PhLotSerialNumberVerifi

Definicja kolumny LotNMVSStatusID tabeli PhLotSerialNumberVerifi

Name

LotNMVSStatusID

Code

LotNMVSStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

Id statusu serii leku z systemu nmvs


Lista kluczy tabeli PhLotSerialNumberVerifi

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhLotSerialNumberVerifi

Definicja klucza Identifier_1 tabeli PhLotSerialNumberVerifi

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment